
const ExcelJS = require('exceljs');
const { NUM } = require('xlsx-populate/lib/FormulaError');


const dateFormat = require('./data') 
module.exports = (req,res)=>{

const data=req.body
// console.log(data);
console.log(data);
let shijiandata= dateFormat.dateFormat(new Date())


let beimu=' '
let kong=' '
    // 判断备选设备
    // 是否有备选模组

    // console.log(data);
 
    
    if(data.bei.muzong!==0){
     

      beimu=`含备用板${data.bei.muzong}张`
      data.wai.muzong=+data.wai.muzong+Number(data.bei.muzong)
      data.wai.mozuzongjia=+data.wai.mozuzongjia+Number(data.bei.muzongjia)
    }


    if(data.bei.kongzhikazong!==0){
      kong =`含备用卡${data.bei.kongzhikazong}张`
      data.wai.kongzhikazong=+data.bei.kongzhikazong+Number(data.wai.kongzhikazong) 
      data.wai.kongzhikazongjia=+data.bei.kongzhikazongjia+Number(data.wai.kongzhikazongjia)
    }
let dia= ' '
if(data.bei.dianyuanshu!==0){
  dia=`含备用电源${data.bei.dianyuanshu}台`
  data.wai.dianyuanshu=+data.wai.dianyuanshu+Number(data.bei.dianyuanshu)

  data.wai.dianyuanzongjia=+data.wai.dianyuanzongjia+Number(data.bei.dianyuanshuzong)

}

let sab=' '
if(data.bei.beitiaoshu!==0){
  sab=`含备用背条${data.bei.beitiaoshu}条`
  data.wai.beitiaoshu=+data.wai.beitiaoshu+Number(data.bei.beitiaoshu)
  data.wai.beitiaozong=+data.wai.beitiaozong+Number(data.bei.beitiaoshujia)
}


let zhua=' '
if(data.bei.zhuanjiaozong!==0){
  zhua=`含备用转角${data.bei.zhuanjiaozong}个`
  data.wai.zhuanjiaozong=+data.wai.zhuanjiaozong+Number(data.bei.zhuanjiaozong)
  data.wai.zhuanjiaozongs=+data.wai.zhuanjiaozongs+Number(data.bei.zhuanjiaozongjia)
}
let adsxz= ' '
if(data.bei.paixianshu!==0){
adsxz=`含备用排线${data.bei.paixianshu}条`
data.wai.paixianshu=+data.wai.paixianshu+Number(data.bei.paixianshu)
data.wai.paixianzong=+data.wai.paixianzong+Number(data.bei.paixianshujia)
}


let wangs =' '
if(data.bei.wangixanshu!==0){
  wangs=`含备用网线${data.bei.wangixanshu}条`
  data.wai.wangixanshu=+ data.wai.wangixanshu+Number(data.bei.wangixanshu)
  data.wai.wangxianzong=+data.wai.wangxianzong+Number(data.bei.wangixanshujia)
}
let heia=' '
if(data.bei.heihongxianshu!==0){
  heia=`含备用黑红线${data.bei.heihongxianshu}`
  data.wai.heihongxianshu=+ data.wai.heihongxianshu+Number(data.bei.heihongxianshu)
  data.wai.heihongzong=+data.wai.heihongzong+Number(data.bei.heihongxianshujia)
}

let sanb=' '
if(data.bei.sanxinxianshu!==0){
  sanb=`含备用三心线${data.bei.sanxinxianshu}条`
  data.wai.sanxinxianshu=+data.wai.sanxinxianshu+Number(data.bei.sanxinxianshu)
  data.wai.sanxinxianzong=+data.wai.sanxinxianzong+Number(data.bei.sanxinxianshujia)
}


// 外部总价
let waibuzong=(Number(data.waibu.fasongkazong)
+Number(data.waibu.chuliqizong)+Number(data.waibu.peidanguizong)+
Number(data.waibu.diannaozong)+Number(data.waibu.kongtiaozong)+
Number(data.waibu.kaungjiazzong)+Number(data.waibu.anzhuangzong)).toFixed(2)



// 选择了税率


let shul= ''
if(data.yusuan.shuilv!==0){
  shul=(+data.wai.pingtizong+Number(data.bei.zongjia)+Number(waibuzong)+(+data.wai.pingtizong+Number(data.bei.zongjia)+Number(waibuzong))*(data.yusuan.shuilv/100)).toFixed(2)
}




    const workbook = new ExcelJS.Workbook();
  const worksheet = workbook.addWorksheet('My Sheet');
  
  // 设置第一列的宽度为20
  worksheet.getColumn(1).width = 20;
  
  // 设置第二列的宽度为30
  worksheet.getColumn(2).width = 20;
  worksheet.getColumn(3).width = 10;
  worksheet.getColumn(4).width = 10;
  worksheet.getColumn(5).width = 10;
  worksheet.getColumn(6).width = 20;
  worksheet.getColumn(7).width = 20;

  // 设置第一行
  worksheet.getCell('A1').value = '报 价 单';
  // 合并第一行
worksheet.mergeCells("A1","H1");
// 第一列样式
worksheet.getCell('A1').style = {
  font: {
    size: 28
  },
  alignment: {
    vertical: 'middle',
    horizontal: 'center'
  }
};

// 设置第二行
// 合并第二行
worksheet.mergeCells("A2","D2");
worksheet.mergeCells("E2","H2");
worksheet.getCell('A2').value = `报价单位：${data.user.nickName}`;
worksheet.getCell('E2').value = '客户单位：';
worksheet.getCell('A2',).style = {
  font: {name:'微软雅黑',
    size: 10,
    bold: true
  }

};
worksheet.getCell(' E2').style = {
  font: {name:'微软雅黑',
    size: 10,
    bold: true
  }

};
// 设置第三行
// 合并第三行
worksheet.mergeCells("A3","D3");
worksheet.mergeCells("E3","H3");
worksheet.getCell('A3').value = '联系人   ：';
worksheet.getCell('E3').value = '联系人   ：';

worksheet.getCell('A3').style = {
  font: {
    name:'微软雅黑',
    size: 10,
    bold: true
  }

};
worksheet.getCell('E3').style = {
  font: {
    name:'微软雅黑',
    size: 10,
    bold: true
  }

};
// 设置第4行
// 合并第4行
worksheet.mergeCells("A4","D4");
worksheet.mergeCells("E4","H4");
worksheet.getCell('A4').value = '电      话：';
worksheet.getCell('E4').value = '电      话：';
worksheet.getCell('A4').style = {
  font: {name:'微软雅黑',
    size: 10,
    bold: true
  }

};
worksheet.getCell('E4').style = {
  font: {name:'微软雅黑',
    size: 10,
    bold: true
  }

};
// 设置第五行
// 合并第5行
worksheet.mergeCells("A5","H5");
worksheet.getCell('A5').value = '一，总体方案';

worksheet.getCell('A5').style = {
  font: {
    name:'微软雅黑',
    size: 12,
    bold: true
  }

};

// 设置第6行
// 合并第6行
worksheet.mergeCells("A6","D6");
worksheet.mergeCells("E6","H6");
worksheet.getCell('A6').value = `品              名：${data.wai.muozuguige}`;
worksheet.getCell('E6').value = `点    间   距：${data.yusuan.dainjianju}`;
worksheet.getCell('A6').style = {
  font: {
    name:'微软雅黑',
    size: 10,
  
  }

};
worksheet.getCell('E6').style = {
  font: {
    name:'微软雅黑',
    size: 10,
   
  }

};

// 设置第7行
// 合并第7行
worksheet.mergeCells("A7","D7");
worksheet.mergeCells("E7","H7");
worksheet.getCell('A7').value = `模组         数量：长${data.wai.pintichang}*高${data.wai.pingtigao} =${data.wai.muzong-Number(data.bei.muzong)}张`;
worksheet.getCell('E7').value = `控制卡数量：长${data.wai.kongzhikachang}*高${data.wai.kongzhikakuan} =${data.wai.kongzhikazong-data.bei.kongzhikazong}`;
worksheet.getCell('E7').style = {
  font: {
    name:'微软雅黑',
    size: 10,
    
  }

};
worksheet.getCell('A7').style = {
  font: {
    name:'微软雅黑',
    size: 10,
 
  }

};
// 设置第8行
// 合并第8行
worksheet.mergeCells("A8","D8");
worksheet.mergeCells("E8","H8");
worksheet.getCell('A8').value = `显示面积(㎡)：${data.wai.xianshimianjichang}*${data.wai.xianshimianjigao} =${data.wai.xianshimianjipingfang}`;
worksheet.getCell('E8').value = `像    素   点：长${(data.wai.pintichang*data.yusuan.xiangsuchang).toFixed(0)}点 * 高${(data.wai.pingtigao*data.yusuan.xiangsugao).toFixed(0)}点 =${(data.wai.pintichang*data.yusuan.xiangsuchang).toFixed(0)*(data.wai.pingtigao*data.yusuan.xiangsugao).toFixed(0)}点`;

worksheet.getCell('A8').style = {
  font: {
    name:'微软雅黑',
    size: 10,
 
  }

};
worksheet.getCell('E8').style = {
  font: {
    name:'微软雅黑',
    size: 10,
 
  }

};
// 设置第9行
// 合并第9行

worksheet.mergeCells("A9","D9");
worksheet.mergeCells("E9","H9");
worksheet.getCell('A9').value = `成品面积(㎡)：${data.wai.chengpinchang}*${data.wai.chengpingao}=${data.wai.chengpinmian}`;
worksheet.getCell('E9').value = `总功率(w)：${data.wai.dianyuanshu*data.yusuan.dianyuangonglv}`;
worksheet.getCell('A9').style = {
  font: {
    name:'微软雅黑',
    size: 10,
  }
};
worksheet.getCell('E9').style = {
  font: {
    name:'微软雅黑',
    size: 10,
  }
};

// 设置第10行
// 合并第10行
worksheet.mergeCells("A10","H10");
worksheet.getCell('A10').value = `二，屏体预算`;
worksheet.getCell('A10').style = {
  font: {
    name:'微软雅黑',
    size: 12,
    bold: true
  },

}; 

worksheet.getCell('A10').style.border = {
  top: {
  
    style: 'medium',
        color: { argb: '#000' }
  },

  left: {
    style: 'medium',
    color: { argb: '#000' },
},
  bottom: {    style: 'medium',
  color: { argb: '#000' },},
  right: {    style: 'medium',
  color: { argb: '#000' },}
};
worksheet.getCell('B10').style.border = {
  top: {
  
    style: 'medium',
        color: { argb: '#000' }
  },

  left: {
    style: 'medium',
    color: { argb: '#000' },
},
  bottom: {    style: 'medium',
  color: { argb: '#000' },},
  right: {    style: 'medium',
  color: { argb: '#000' },}
};
worksheet.getCell('C10').style.border = {
  top: {
  
    style: 'medium',
        color: { argb: '#000' }
  },


};
worksheet.getCell('D10').style.border = {
  top: {
  
    style: 'medium',
        color: { argb: '#000' }
  },


};
worksheet.getCell('E10').style.border = {
  top: {
  
    style: 'medium',
        color: { argb: '#000' }
  },


};
worksheet.getCell('F10').style.border = {
  top: {
  
    style: 'medium',
        color: { argb: '#000' }
  },


};

worksheet.getCell('G10').style.border = {
  top: {
  
    style: 'medium',
        color: { argb: '#000' }
  },


};
worksheet.getCell('H10').style.border = {
  top: {
  
    style: 'medium',
        color: { argb: '#000' }
  },


  bottom: {    style: 'medium',
  color: { argb: '#000' },},
  right: {    style: 'medium',
  color: { argb: '#000' },}
};
// 设置第11行
// 合并第11行
// worksheet.mergeCells("A11","H11");
worksheet.getCell('A11').value = `品名`;
worksheet.getCell('A11').style = {
  font: {
    name:'微软雅黑',
    size: 10,
    bold: true
  }

};
// 字体对齐
worksheet.getCell('A11').alignment = { horizontal: 'center', vertical: 'middle' };
// 边框颜色
worksheet.getCell('A11').style.border = {
  left: {    style: 'medium',
  color: { argb: '#000' },},
  bottom: {    style: 'thin',
  color: { argb: '#000' },},
};
// 背景色
worksheet.getCell('A11').fill = {
  type: 'pattern',
  pattern: 'solid',
  fgColor: {argb:'c6e0b4'}
};


// 

worksheet.getCell('B11').value = `规格型号`;
worksheet.getCell('B11').style = {
  font: {
    name:'微软雅黑',
    size: 10,
    bold: true
  }

};
worksheet.getCell('B11').fill = {
  type: 'pattern',
  pattern: 'solid',
  fgColor: {argb:'c6e0b4'}
};
worksheet.getCell('B11').alignment = { horizontal: 'center', vertical: 'middle' };

worksheet.getCell('B11').style.border = {
  left: {    style: 'thin',
  color: { argb: '#000' },},
  bottom: {    style: 'thin',
  color: { argb: '#000' },},
};



worksheet.getCell('C11').value = `数量`;
worksheet.getCell('C11').style = {
  font: {
    name:'微软雅黑',
    size: 10,
    bold: true
  }

};
worksheet.getCell('C11').fill = {
  type: 'pattern',
  pattern: 'solid',
  fgColor: {argb:'c6e0b4'}
};
worksheet.getCell('C11').alignment = { horizontal: 'center', vertical: 'middle' };

worksheet.getCell('C11').style.border = {
  left: {    style: 'thin',
  color: { argb: '#000' },}
  ,
  bottom: {    style: 'thin',
  color: { argb: '#000' },},
};
worksheet.getCell('D11').value = `单位`;
worksheet.getCell('D11').style = {
  font: {
    name:'微软雅黑',
    size: 10,
    bold: true
  }

};
worksheet.getCell('D11').fill = {
  type: 'pattern',
  pattern: 'solid',
  fgColor: {argb:'c6e0b4'}
};
worksheet.getCell('D11').alignment = { horizontal: 'center', vertical: 'middle' };

worksheet.getCell('D11').style.border = {
  left: {    style: 'thin',
  color: { argb: '#000' },},
  bottom: {    style: 'thin',
  color: { argb: '#000' },},
};


worksheet.getCell('E11').value = `单价`;
worksheet.getCell('E11').style = {
  font: {
    name:'微软雅黑',
    size: 10,
    bold: true
  }

};
worksheet.getCell('E11').fill = {
  type: 'pattern',
  pattern: 'solid',
  fgColor: {argb:'c6e0b4'}
};
worksheet.getCell('E11').alignment = { horizontal: 'center', vertical: 'middle' };

worksheet.getCell('E11').style.border = {
  left: {    style: 'thin',
  color: { argb: '#000' },},
  bottom: {    style: 'thin',
  color: { argb: '#000' },},
};





worksheet.getCell('F11').value = `金额(元)`;
worksheet.getCell('F11').style = {
  font: {
    name:'微软雅黑',
    size: 10,
    bold: true
  }

};
worksheet.getCell('F11').fill = {
  type: 'pattern',
  pattern: 'solid',
  fgColor: {argb:'c6e0b4'},

};
worksheet.getCell('F11').alignment = { horizontal: 'center', vertical: 'middle' };

worksheet.getCell('F11').style.border = {
  left: {    style: 'thin',
  color: { argb: '#000' },},  bottom: {    style: 'thin',
  color: { argb: '#000' },},
};
worksheet.mergeCells("G11","H11");
worksheet.getCell('G11').value = `备注`;
worksheet.getCell('G11').style = {
  font: {
    name:'微软雅黑',
    size: 10,
    bold: true
  }

};
worksheet.getCell('G11').fill = {
  type: 'pattern',
  pattern: 'solid',
  fgColor: {argb:'c6e0b4'},

};
worksheet.getCell('G11').alignment = { horizontal: 'center', vertical: 'middle' };

worksheet.getCell('G11').style.border = {
  left: {    style: 'thin',
  color: { argb: '#000' },},  bottom: {    style: 'thin',
  color: { argb: '#000' },},
};

worksheet.getCell('H11').fill = {
  type: 'pattern',
  pattern: 'solid',
  fgColor: {argb:'c6e0b4'}
};
worksheet.getCell('H11').style.border = {
  right: {    style: 'medium',
  color: { argb: '#000' },}
  ,
  bottom: {    style: 'thin',
  color: { argb: '#000' },},
};


worksheet.getCell('A12').value = `模组`;
worksheet.getCell('A12').style = {
  font: {
    name:'微软雅黑',
    size: 10,
  
  }

};
worksheet.getCell('A12').alignment = { horizontal: 'center', vertical: 'middle' };


worksheet.getCell('A12').style.border = {
  left: {    style: 'medium',
  color: { argb: '#000' },},

};



worksheet.getCell('B12').value = `${data.wai.muozuguige}`;
worksheet.getCell('B12').style = {
  font: {
    name:'微软雅黑',
    size: 10,
  
  }

};
worksheet.getCell('B12').alignment = { horizontal: 'center', vertical: 'middle' };

worksheet.getCell('C12').value = `${data.wai.muzong}`;
worksheet.getCell('C12').style = {
  font: {
    name:'微软雅黑',
    size: 10,
  
  }

};
worksheet.getCell('C12').alignment = { horizontal: 'center', vertical: 'middle' };

worksheet.getCell('D12').value = `张`;
worksheet.getCell('D12').style = {
  font: {
    name:'微软雅黑',
    size: 10,
  
  }

};
worksheet.getCell('D12').alignment = { horizontal: 'center', vertical: 'middle' };


worksheet.getCell('E12').value = `${data.wai.mozudanjia}`;
worksheet.getCell('E12').style = {
  font: {
    name:'微软雅黑',
    size: 10,
  
  }

};
worksheet.getCell('E12').alignment = { horizontal: 'center', vertical: 'middle' };



worksheet.getCell('F12').value = `${data.wai.mozuzongjia}`;
worksheet.getCell('F12').style = {
  font: {
    name:'微软雅黑',
    size: 10,
  
  }

};
worksheet.getCell('F12').alignment = { horizontal: 'center', vertical: 'middle' };

worksheet.getCell('G12').value=beimu
worksheet.mergeCells("G12","H12");

worksheet.getCell('H12').style.border={
  right: {    style: 'medium',
  color: { argb: '#000' },}
}

worksheet.getCell('A13').value = `接收卡`;
worksheet.getCell('A13').style = {
  font: {
    name:'微软雅黑',
    size: 10,
  
  }

};

worksheet.getCell('A13').alignment = { horizontal: 'center', vertical: 'middle' };

worksheet.getCell('A13').style.border = {

  left: {    style: 'medium',
  color: { argb: '#000' },}
};



worksheet.getCell('B13').value = `${data.wai.hoangzhikaguige}`;


worksheet.getCell('B13').style = {
  font: {
    name:'微软雅黑',
    size: 10,
  
  }

};

worksheet.getCell('B13').alignment = { horizontal: 'center', vertical: 'middle' };




worksheet.getCell('C13').value = `${data.wai.kongzhikazong}`;


worksheet.getCell('C13').style = {
  font: {
    name:'微软雅黑',
    size: 10,
  
  }

};

worksheet.getCell('C13').alignment = { horizontal: 'center', vertical: 'middle' };




worksheet.getCell('D13').value = `张`;


worksheet.getCell('D13').style = {
  font: {
    name:'微软雅黑',
    size: 10,
  
  }

};

worksheet.getCell('D13').alignment = { horizontal: 'center', vertical: 'middle' };




worksheet.getCell('E13').value = `${data.wai.kongzhikadanjia}`;


worksheet.getCell('E13').style = {
  font: {
    name:'微软雅黑',
    size: 10,
  
  }

};

worksheet.getCell('E13').alignment = { horizontal: 'center', vertical: 'middle' };



worksheet.getCell('F13').value = `${data.wai.kongzhikazongjia}`;


worksheet.getCell('F13').style = {
  font: {
    name:'微软雅黑',
    size: 10,
  
  }

};

worksheet.getCell('F13').alignment = { horizontal: 'center', vertical: 'middle' };
worksheet.getCell('G13').value=kong
worksheet.mergeCells("G13","H13");

worksheet.getCell('H13').style.border={
  right: {    style: 'medium',
  color: { argb: '#000' },}
}
worksheet.getCell('G14').value=dia

worksheet.mergeCells("G14","H14");
worksheet.getCell('H14').style.border={
  right: {    style: 'medium',
  color: { argb: '#000' },}
}


worksheet.getCell('A14').value = `电源`;

worksheet.getCell('A14').style = {
  font: {
    name:'微软雅黑',
    size: 10,
  
  }

};

worksheet.getCell('A14').alignment = { horizontal: 'center', vertical: 'middle' };


worksheet.getCell('A14').style.border = {

  left: {    style: 'medium',
  color: { argb: '#000' },}
};

worksheet.getCell('B14').value = `${data.wai.dinyuanguioge}`;

worksheet.getCell('B14').style = {
  font: {
    name:'微软雅黑',
    size: 10,
  
  }

};

worksheet.getCell('B14').alignment = { horizontal: 'center', vertical: 'middle' };




worksheet.getCell('C14').value = `${data.wai.dianyuanshu}`;

worksheet.getCell('C14').style = {
  font: {
    name:'微软雅黑',
    size: 10,
  
  }

};

worksheet.getCell('C14').alignment = { horizontal: 'center', vertical: 'middle' };




worksheet.getCell('D14').value = `台`;

worksheet.getCell('D14').style = {
  font: {
    name:'微软雅黑',
    size: 10,
  
  }

};

worksheet.getCell('D14').alignment = { horizontal: 'center', vertical: 'middle' };





worksheet.getCell('E14').value = `${data.wai.dianyuandanjia}`;

worksheet.getCell('E14').style = {
  font: {
    name:'微软雅黑',
    size: 10,
  
  }

};

worksheet.getCell('E14').alignment = { horizontal: 'center', vertical: 'middle' };






worksheet.getCell('F14').value = `${data.wai.dianyuanzongjia}`;

worksheet.getCell('F14').style = {
  font: {
    name:'微软雅黑',
    size: 10,
  
  }

};

worksheet.getCell('F14').alignment = { horizontal: 'center', vertical: 'middle' };





worksheet.getCell('A15').value = `边框`;


worksheet.getCell('A15').style = {
  font: {
    name:'微软雅黑',
    size: 10,
  
  }

};

worksheet.getCell('A15').alignment = { horizontal: 'center', vertical: 'middle' };
worksheet.getCell('A15').style.border = {

  left: {    style: 'medium',
  color: { argb: '#000' },}
};

worksheet.getCell('B15').value = `${data.wai.kuangjiaguige}`;
worksheet.getCell('B15').style = {
  font: {
    name:'微软雅黑',
    size: 10,
  
  }

};
worksheet.getCell('B15').alignment = { horizontal: 'center', vertical: 'middle' };




worksheet.getCell('C15').value = `${data.wai.kuangjiashu}`;
worksheet.getCell('C15').style = {
  font: {
    name:'微软雅黑',
    size: 10,
  
  }

};
worksheet.getCell('C15').alignment = { horizontal: 'center', vertical: 'middle' };




worksheet.getCell('D15').value = `根`;
worksheet.getCell('D15').style = {
  font: {
    name:'微软雅黑',
    size: 10,
  
  }

};
worksheet.getCell('D15').alignment = { horizontal: 'center', vertical: 'middle' };


worksheet.getCell('E15').value = `${data.wai.kaungjidanjai}`;
worksheet.getCell('E15').style = {
  font: {
    name:'微软雅黑',
    size: 10,
  
  }

};
worksheet.getCell('E15').alignment = { horizontal: 'center', vertical: 'middle' };


worksheet.getCell('F15').value = `${data.wai.kuangjiazong}`;
worksheet.getCell('F15').style = {
  font: {
    name:'微软雅黑',
    size: 10,
  
  }

};
worksheet.getCell('F15').alignment = { horizontal: 'center', vertical: 'middle' };

worksheet.mergeCells("G15","H15");

worksheet.getCell('H15').style.border={
  right: {    style: 'medium',
  color: { argb: '#000' },}
}



worksheet.getCell('A16').value = `转角`;


worksheet.getCell('A16').style = {
  font: {
    name:'微软雅黑',
    size: 10,
  
  }

};

worksheet.getCell('A16').alignment = { horizontal: 'center', vertical: 'middle' };

worksheet.getCell('A16').style.border = {

  left: {    style: 'medium',
  color: { argb: '#000' },}
};


worksheet.getCell('B16').value = `${data.wai.zhuanjiaoguige}`;
worksheet.getCell('B16').style = {
  font: {
    name:'微软雅黑',
    size: 10,
  
  }

};
worksheet.getCell('B16').alignment = { horizontal: 'center', vertical: 'middle' };


worksheet.getCell('C16').value = `${data.wai.zhuanjiaozong}`;
worksheet.getCell('C16').style = {
  font: {
    name:'微软雅黑',
    size: 10,
  
  }

};
worksheet.getCell('C16').alignment = { horizontal: 'center', vertical: 'middle' };


worksheet.getCell('D16').value = `个`;
worksheet.getCell('D16').style = {
  font: {
    name:'微软雅黑',
    size: 10,
  
  }

};
worksheet.getCell('D16').alignment = { horizontal: 'center', vertical: 'middle' };




worksheet.getCell('E16').value = `${data.wai.zhuanjiaodan}`;
worksheet.getCell('E16').style = {
  font: {
    name:'微软雅黑',
    size: 10,
  
  }

};
worksheet.getCell('E16').alignment = { horizontal: 'center', vertical: 'middle' };




worksheet.getCell('F16').value = `${data.wai.zhuanjiaozongs}`;
worksheet.getCell('F16').style = {
  font: {
    name:'微软雅黑',
    size: 10,
  
  }

};
worksheet.getCell('F16').alignment = { horizontal: 'center', vertical: 'middle' };

worksheet.getCell('G16').value=zhua

worksheet.mergeCells("G16","H16");

worksheet.getCell('H16').style.border={
  right: {    style: 'medium',
  color: { argb: '#000' },}
}



worksheet.getCell('A17').value = `背条`;


worksheet.getCell('A17').style = {
  font: {
    name:'微软雅黑',
    size: 10,
  
  }

};

worksheet.getCell('A17').alignment = { horizontal: 'center', vertical: 'middle' };

worksheet.getCell('A17').style.border = {

  left: {    style: 'medium',
  color: { argb: '#000' },}
};



worksheet.getCell('B17').value = `${data.wai.neitiaoname}`;
worksheet.getCell('B17').style = {
  font: {
    name:'微软雅黑',
    size: 10,
  
  }

};
worksheet.getCell('B17').alignment = { horizontal: 'center', vertical: 'middle' };

worksheet.getCell('C17').value = `${data.wai.beitiaoshu}`;
worksheet.getCell('C17').style = {
  font: {
    name:'微软雅黑',
    size: 10,
  
  }

};
worksheet.getCell('C17').alignment = { horizontal: 'center', vertical: 'middle' };


worksheet.getCell('D17').value = `根`;
worksheet.getCell('D17').style = {
  font: {
    name:'微软雅黑',
    size: 10,
  
  }

};
worksheet.getCell('D17').alignment = { horizontal: 'center', vertical: 'middle' };



worksheet.getCell('E17').value = `${data.wai.bietiaodan}`;
worksheet.getCell('E17').style = {
  font: {
    name:'微软雅黑',
    size: 10,
  
  }

};
worksheet.getCell('E17').alignment = { horizontal: 'center', vertical: 'middle' };




worksheet.getCell('F17').value = `${data.wai.beitiaozong}`;
worksheet.getCell('F17').style = {
  font: {
    name:'微软雅黑',
    size: 10,
  
  }

};
worksheet.getCell('F17').alignment = { horizontal: 'center', vertical: 'middle' };

worksheet.getCell('G17').value=sab
worksheet.mergeCells("G17","H17");


worksheet.getCell('H17').style.border={
  right: {    style: 'medium',
  color: { argb: '#000' },}
}






worksheet.getCell('A18').value = `网线`;


worksheet.getCell('A18').style = {
  font: {
    name:'微软雅黑',
    size: 10,
  
  }

};

worksheet.getCell('A18').alignment = { horizontal: 'center', vertical: 'middle' };

worksheet.getCell('A18').style.border = {

  left: {    style: 'medium',
  color: { argb: '#000' },}
};



worksheet.getCell('B18').value = `${data.wai.wangxianname}`;
worksheet.getCell('B18').style = {
  font: {
    name:'微软雅黑',
    size: 10,
  
  }

};
worksheet.getCell('B18').alignment = { horizontal: 'center', vertical: 'middle' };

worksheet.getCell('C18').value = `${data.wai.wangixanshu}`;
worksheet.getCell('C18').style = {
  font: {
    name:'微软雅黑',
    size: 10,
  
  }

};
worksheet.getCell('C18').alignment = { horizontal: 'center', vertical: 'middle' };


worksheet.getCell('D18').value = `根`;
worksheet.getCell('D18').style = {
  font: {
    name:'微软雅黑',
    size: 10,
  
  }

};
worksheet.getCell('D18').alignment = { horizontal: 'center', vertical: 'middle' };



worksheet.getCell('E18').value = `${data.wai.wangxiandanjia}`;
worksheet.getCell('E18').style = {
  font: {
    name:'微软雅黑',
    size: 10,
  
  }

};
worksheet.getCell('E18').alignment = { horizontal: 'center', vertical: 'middle' };




worksheet.getCell('F18').value = `${data.wai.wangxianzong}`;
worksheet.getCell('F18').style = {
  font: {
    name:'微软雅黑',
    size: 10,
  
  }

};
worksheet.getCell('F18').alignment = { horizontal: 'center', vertical: 'middle' };

worksheet.getCell('G18').value=wangs
worksheet.mergeCells("G18","H18");


worksheet.getCell('H18').style.border={
  right: {    style: 'medium',
  color: { argb: '#000' },}
}



worksheet.getCell('A19').value = `排线`;


worksheet.getCell('A19').style = {
  font: {
    name:'微软雅黑',
    size: 10,
  
  }

};

worksheet.getCell('A19').alignment = { horizontal: 'center', vertical: 'middle' };
worksheet.getCell('A19').style.border = {
 
  left: {    style: 'medium',
  color: { argb: '#000' },}
};




worksheet.getCell('B19').value = `${data.wai.paixianname}`;
worksheet.getCell('B19').style = {
  font: {
    name:'微软雅黑',
    size: 10,
  
  }

};
worksheet.getCell('B19').alignment = { horizontal: 'center', vertical: 'middle' };

worksheet.getCell('C19').value = `${data.wai.paixianshu}`;
worksheet.getCell('C19').style = {
  font: {
    name:'微软雅黑',
    size: 10,
  
  }

};
worksheet.getCell('C19').alignment = { horizontal: 'center', vertical: 'middle' };


worksheet.getCell('D19').value = `根`;
worksheet.getCell('D19').style = {
  font: {
    name:'微软雅黑',
    size: 10,
  
  }

};
worksheet.getCell('D19').alignment = { horizontal: 'center', vertical: 'middle' };



worksheet.getCell('E19').value = `${data.wai.paixiandanjia}`;
worksheet.getCell('E19').style = {
  font: {
    name:'微软雅黑',
    size: 10,
  
  }

};
worksheet.getCell('E19').alignment = { horizontal: 'center', vertical: 'middle' };




worksheet.getCell('F19').value = `${data.wai.paixianzong}`;
worksheet.getCell('F19').style = {
  font: {
    name:'微软雅黑',
    size: 10,
  
  }

};
worksheet.getCell('F19').alignment = { horizontal: 'center', vertical: 'middle' };
worksheet.getCell('G19').value=adsxz
worksheet.mergeCells("G19","H19");


worksheet.getCell('H19').style.border={
  right: {    style: 'medium',
  color: { argb: '#000' },}
}




worksheet.getCell('A20').value = `黑红线`;


worksheet.getCell('A20').style = {
  font: {
    name:'微软雅黑',
    size: 10,
  
  }

};

worksheet.getCell('A20').alignment = { horizontal: 'center', vertical: 'middle' };

worksheet.getCell('A20').style.border = {

  left: {    style: 'medium',
  color: { argb: '#000' },}
};



worksheet.getCell('B20').value = `${data.wai.hiehongxianname}`;
worksheet.getCell('B20').style = {
  font: {
    name:'微软雅黑',
    size: 10,
  
  }

};
worksheet.getCell('B20').alignment = { horizontal: 'center', vertical: 'middle' };

worksheet.getCell('C20').value = `${data.wai.heihongxianshu}`;
worksheet.getCell('C20').style = {
  font: {
    name:'微软雅黑',
    size: 10,
  
  }

};
worksheet.getCell('C20').alignment = { horizontal: 'center', vertical: 'middle' };


worksheet.getCell('D20').value = `对`;
worksheet.getCell('D20').style = {
  font: {
    name:'微软雅黑',
    size: 10,
  
  }

};
worksheet.getCell('D20').alignment = { horizontal: 'center', vertical: 'middle' };



worksheet.getCell('E20').value = `${data.wai.hiehongdanjia}`;
worksheet.getCell('E20').style = {
  font: {
    name:'微软雅黑',
    size: 10,
  
  }

};
worksheet.getCell('E20').alignment = { horizontal: 'center', vertical: 'middle' };




worksheet.getCell('F20').value = `${data.wai.heihongzong}`;
worksheet.getCell('F20').style = {
  font: {
    name:'微软雅黑',
    size: 10,
  
  }

};
worksheet.getCell('F20').alignment = { horizontal: 'center', vertical: 'middle' };
worksheet.getCell('G20').value=heia
worksheet.mergeCells("G20","H20");


worksheet.getCell('H20').style.border={
  right: {    style: 'medium',
  color: { argb: '#000' },}
}





worksheet.getCell('A21').value = `三心线`;


worksheet.getCell('A21').style = {
  font: {
    name:'微软雅黑',
    size: 10,
  
  }

};

worksheet.getCell('A21').alignment = { horizontal: 'center', vertical: 'middle' };

worksheet.getCell('A21').style.border = {

  left: {    style: 'medium',
  color: { argb: '#000' },}
};



worksheet.getCell('B21').value = `${data.wai.sanxinxianname}`;
worksheet.getCell('B21').style = {
  font: {
    name:'微软雅黑',
    size: 10,
  
  }

};
worksheet.getCell('B21').alignment = { horizontal: 'center', vertical: 'middle' };

worksheet.getCell('C21').value = `${data.wai.sanxinxianshu}`;
worksheet.getCell('C21').style = {
  font: {
    name:'微软雅黑',
    size: 10,
  
  }

};
worksheet.getCell('C21').alignment = { horizontal: 'center', vertical: 'middle' };


worksheet.getCell('D21').value = `根`;
worksheet.getCell('D21').style = {
  font: {
    name:'微软雅黑',
    size: 10,
  
  }

};
worksheet.getCell('D21').alignment = { horizontal: 'center', vertical: 'middle' };



worksheet.getCell('E21').value = `${data.wai.sanxinxiandanjia}`;
worksheet.getCell('E21').style = {
  font: {
    name:'微软雅黑',
    size: 10,
  
  }

};
worksheet.getCell('E21').alignment = { horizontal: 'center', vertical: 'middle' };




worksheet.getCell('F21').value = `${data.wai.sanxinxianzong}`;
worksheet.getCell('F21').style = {
  font: {
    name:'微软雅黑',
    size: 10,
  
  }

};
worksheet.getCell('F21').alignment = { horizontal: 'center', vertical: 'middle' };
worksheet.getCell('G21').value=sanb
worksheet.mergeCells("G21","H21");


worksheet.getCell('H21').style.border={
  right: {    style: 'medium',
  color: { argb: '#000' },}
}






worksheet.getCell('A22').value = `箱体`;


worksheet.getCell('A22').style = {
  font: {
    name:'微软雅黑',
    size: 10,
  
  }

};

worksheet.getCell('A22').alignment = { horizontal: 'center', vertical: 'middle' };

worksheet.getCell('A22').style.border = {
 
  left: {    style: 'medium',
  color: { argb: '#000' },}
};



worksheet.getCell('B22').value = `${data.wai.xiangtiname}`;
worksheet.getCell('B22').style = {
  font: {
    name:'微软雅黑',
    size: 10,
  
  }

};
worksheet.getCell('B22').alignment = { horizontal: 'center', vertical: 'middle' };

worksheet.getCell('C22').value = `${(data.wai.xiangtishu).toFixed(2)}`;
worksheet.getCell('C22').style = {
  font: {
    name:'微软雅黑',
    size: 10,
  
  }

};
worksheet.getCell('C22').alignment = { horizontal: 'center', vertical: 'middle' };


worksheet.getCell('D22').value = `平方`;
worksheet.getCell('D22').style = {
  font: {
    name:'微软雅黑',
    size: 10,
  
  }

};
worksheet.getCell('D22').alignment = { horizontal: 'center', vertical: 'middle' };



worksheet.getCell('E22').value = `${data.wai.xiangtidanjia}`;
worksheet.getCell('E22').style = {
  font: {
    name:'微软雅黑',
    size: 10,
  
  }

};
worksheet.getCell('E22').alignment = { horizontal: 'center', vertical: 'middle' };




worksheet.getCell('F22').value = `${data.wai.xiangtizong}`;
worksheet.getCell('F22').style = {
  font: {
    name:'微软雅黑',
    size: 10,
  
  }

};
worksheet.getCell('F22').alignment = { horizontal: 'center', vertical: 'middle' };

worksheet.mergeCells("G22","H22");


worksheet.getCell('H22').style.border={
  right: {    style: 'medium',
  color: { argb: '#000' },}
}




worksheet.getCell('A23').value = `组装箱体`;


worksheet.getCell('A23').style = {
  font: {
    name:'微软雅黑',
    size: 10,
  
  }

};

worksheet.getCell('A23').alignment = { horizontal: 'center', vertical: 'middle' };

worksheet.getCell('A23').style.border = {

  left: {    style: 'medium',
  color: { argb: '#000' },}
};



worksheet.getCell('B23').value = `${data.wai.zuzhuangboxname}`;
worksheet.getCell('B23').style = {
  font: {
    name:'微软雅黑',
    size: 10,
  
  }

};
worksheet.getCell('B23').alignment = { horizontal: 'center', vertical: 'middle' };

worksheet.getCell('C23').value = `${data.wai.zuzhuangshu}`;
worksheet.getCell('C23').style = {
  font: {
    name:'微软雅黑',
    size: 10,
  
  }

};
worksheet.getCell('C23').alignment = { horizontal: 'center', vertical: 'middle' };


worksheet.getCell('D23').value = `平方`;
worksheet.getCell('D23').style = {
  font: {
    name:'微软雅黑',
    size: 10,
  
  }

};
worksheet.getCell('D23').alignment = { horizontal: 'center', vertical: 'middle' };



worksheet.getCell('E23').value = `${data.wai.zuzhuangdanjia}`;
worksheet.getCell('E23').style = {
  font: {
    name:'微软雅黑',
    size: 10,
  
  }

};
worksheet.getCell('E23').alignment = { horizontal: 'center', vertical: 'middle' };




worksheet.getCell('F23').value = `${data.wai.zuzhuangzong}`;
worksheet.getCell('F23').style = {
  font: {
    name:'微软雅黑',
    size: 10,
  
  }

};
worksheet.getCell('F23').alignment = { horizontal: 'center', vertical: 'middle' };

worksheet.mergeCells("G23","H23");


worksheet.getCell('H23').style.border={
  right: {    style: 'medium',
  color: { argb: '#000' },}
}

worksheet.getCell('A24').value = `屏体小计：`;
worksheet.mergeCells("A24","E24");
// 
  worksheet.getCell('A24').style = {
    font: {
      name:'微软雅黑',
      size: 12,
      bold:true
    
    },
    alignment:{ horizontal: 'right', vertical: 'middle' },
    border:{
        left: {    style: 'medium',
        color: { argb: '#000' },},
        bottom: {    style: 'medium',
        color: { argb: '#000' },}
      }
  
  };

  worksheet.getCell('F24').value = `${(+data.wai.pingtizong+Number(data.bei.zongjia)).toFixed(2)}`;
worksheet.mergeCells("G24","H24");
// 
  worksheet.getCell('F24').style = {
    font: {
      name:'微软雅黑',
      size: 12,
      bold:true
    
    },
    alignment:{ horizontal: 'center', vertical: 'middle' },
    border:{
      
        bottom: {    style: 'medium',
        color: { argb: '#000' },}
      }
  
  };
  worksheet.getCell('B24').style = {
  
    border:{
      
        bottom: {    style: 'medium',
        color: { argb: '#000' },}
      }
  
  };
  worksheet.getCell('C24').style = {
  
    border:{
      
        bottom: {    style: 'medium',
        color: { argb: '#000' },}
      }
  
  };
  worksheet.getCell('D24').style = {
  
    border:{
      
        bottom: {    style: 'medium',
        color: { argb: '#000' },}
      }
  
  };
  worksheet.getCell('E24').style = {
  
    border:{
      
        bottom: {    style: 'medium',
        color: { argb: '#000' },}
      }
  
  };
  worksheet.getCell('G24').style = {
    font: {
        name:'微软雅黑',
          size: 12,
           bold:true
          
          },
           alignment:{ horizontal: 'center', vertical: 'middle' },
    border:{
      
        bottom: {    style: 'medium',
        color: { argb: '#000' },}
      }
  
  };
  worksheet.getCell('G24').value='未税金额'
  worksheet.getCell('H24').style = {
  
        
    border:{
        right: {    style: 'medium',
        color: { argb: '#000' },},
        bottom: {    style: 'medium',
        color: { argb: '#000' },}
      }
  
  };
// worksheet.getCell('A24').



worksheet.mergeCells("A25","H25");
worksheet.getCell('A25').value = `三，外部预算`;
worksheet.getCell('A25').style = {
  font: {
    name:'微软雅黑',
    size: 12,
    bold: true
  },

}; 

worksheet.getCell('A25').style.border = {
  top: {
  
    style: 'medium',
        color: { argb: '#000' }
  },

  left: {
    style: 'medium',
    color: { argb: '#000' },
},
  bottom: {    style: 'medium',
  color: { argb: '#000' },},
  right: {    style: 'medium',
  color: { argb: '#000' },}
};
worksheet.getCell('B25').style.border = {
  top: {
  
    style: 'medium',
        color: { argb: '#000' }
  },

  left: {
    style: 'medium',
    color: { argb: '#000' },
},
  bottom: {    style: 'medium',
  color: { argb: '#000' },},
  right: {    style: 'medium',
  color: { argb: '#000' },}
};
worksheet.getCell('C25').style.border = {
  top: {
  
    style: 'medium',
        color: { argb: '#000' }
  },


};
worksheet.getCell('D25').style.border = {
  top: {
  
    style: 'medium',
        color: { argb: '#000' }
  },


};
worksheet.getCell('E25').style.border = {
  top: {
  
    style: 'medium',
        color: { argb: '#000' }
  },


};
worksheet.getCell('F25').style.border = {
  top: {
  
    style: 'medium',
        color: { argb: '#000' }
  },


};

worksheet.getCell('G25').style.border = {
  top: {
  
    style: 'medium',
        color: { argb: '#000' }
  },


};
worksheet.getCell('H25').style.border = {
  top: {
  
    style: 'medium',
        color: { argb: '#000' }
  },


  bottom: {    style: 'medium',
  color: { argb: '#000' },},
  right: {    style: 'medium',
  color: { argb: '#000' },}
};





worksheet.getCell('A26').value = `品名`;
worksheet.getCell('A26').style = {
  font: {
    name:'微软雅黑',
    size: 10,
    bold: true
  }

};
worksheet.getCell('A26').fill = {
  type: 'pattern',
  pattern: 'solid',
  fgColor: {argb:'c6e0b4'}
};
worksheet.getCell('A26').alignment = { horizontal: 'center', vertical: 'middle' };

worksheet.getCell('A26').style.border = {
  left: {    style: 'medium',
  color: { argb: '#000' },},  bottom: {    style: 'thin',
  color: { argb: '#000' },},
};





worksheet.getCell('B26').value = `规格型号`;
worksheet.getCell('B26').style = {
  font: {
    name:'微软雅黑',
    size: 10,
    bold: true
  }

};
worksheet.getCell('B26').fill = {
  type: 'pattern',
  pattern: 'solid',
  fgColor: {argb:'c6e0b4'}
};
worksheet.getCell('B26').alignment = { horizontal: 'center', vertical: 'middle' };

worksheet.getCell('B26').style.border = {
  left: {    style: 'thin',
  color: { argb: '#000' },},  bottom: {    style: 'thin',
  color: { argb: '#000' },},
};






worksheet.getCell('C26').value = `数量`;
worksheet.getCell('C26').style = {
  font: {
    name:'微软雅黑',
    size: 10,
    bold: true
  }

};
worksheet.getCell('C26').fill = {
  type: 'pattern',
  pattern: 'solid',
  fgColor: {argb:'c6e0b4'}
};
worksheet.getCell('C26').alignment = { horizontal: 'center', vertical: 'middle' };

worksheet.getCell('C26').style.border = {
  left: {    style: 'thin',
  color: { argb: '#000' },},  bottom: {    style: 'thin',
  color: { argb: '#000' },},
};







worksheet.getCell('D26').value = `单位`;
worksheet.getCell('D26').style = {
  font: {
    name:'微软雅黑',
    size: 10,
    bold: true
  }

};
worksheet.getCell('D26').fill = {
  type: 'pattern',
  pattern: 'solid',
  fgColor: {argb:'c6e0b4'}
};
worksheet.getCell('D26').alignment = { horizontal: 'center', vertical: 'middle' };

worksheet.getCell('D26').style.border = {
  left: {    style: 'thin',
  color: { argb: '#000' },},  bottom: {    style: 'thin',
  color: { argb: '#000' },},
};







worksheet.getCell('E26').value = `单价`;
worksheet.getCell('E26').style = {
  font: {
    name:'微软雅黑',
    size: 10,
    bold: true
  }

};
worksheet.getCell('E26').fill = {
  type: 'pattern',
  pattern: 'solid',
  fgColor: {argb:'c6e0b4'}
};
worksheet.getCell('E26').alignment = { horizontal: 'center', vertical: 'middle' };

worksheet.getCell('E26').style.border = {
  left: {    style: 'thin',
  color: { argb: '#000' },},  bottom: {    style: 'thin',
  color: { argb: '#000' },},
};









worksheet.getCell('F26').value = `金额(元)`;
worksheet.getCell('F26').style = {
  font: {
    name:'微软雅黑',
    size: 10,
    bold: true
  }

};
worksheet.getCell('F26').fill = {
  type: 'pattern',
  pattern: 'solid',
  fgColor: {argb:'c6e0b4'}
};
worksheet.getCell('F26').alignment = { horizontal: 'center', vertical: 'middle' };

worksheet.getCell('F26').style.border = {
  left: {    style: 'thin',
  color: { argb: '#000' },},  bottom: {    style: 'thin',
  color: { argb: '#000' },},
};





worksheet.getCell('G26').value = `备注`;
worksheet.mergeCells("G26","H26");
worksheet.getCell('G26').style = {
  font: {
    name:'微软雅黑',
    size: 10,
    bold: true
  }

};
worksheet.getCell('G26').fill = {
  type: 'pattern',
  pattern: 'solid',
  fgColor: {argb:'c6e0b4'}
};
worksheet.getCell('G26').alignment = { horizontal: 'center', vertical: 'middle' };

worksheet.getCell('G26').style.border = {
  left: {    style: 'thin',
  color: { argb: '#000' },},  bottom: {    style: 'thin',
  color: { argb: '#000' },},
};

worksheet.getCell('H26').style.border = {
    left: {    style: 'thin',
    color: { argb: '#000' },},
    right: {    style: 'medium',
    color: { argb: '#000' },},  bottom: {    style: 'thin',
    color: { argb: '#000' },},
  };

  worksheet.getCell('A27').value = `发送卡`;




  worksheet.getCell('A27').style = {
    font: {
      name:'微软雅黑',
      size: 10,
    
    }
  
  };
  
  worksheet.getCell('A27').alignment = { horizontal: 'center', vertical: 'middle' };
  worksheet.getCell('A27').style.border = {
   
    left: {    style: 'medium',
  color: { argb: '#000' },}
  };
  worksheet.getCell('B27').value = `${data.waibu.fasongka}`;
  worksheet.getCell('B27').style = {
    font: {
      name:'微软雅黑',
      size: 10,
    
    }
  
  };
  worksheet.getCell('B27').alignment = { horizontal: 'center', vertical: 'middle' };
  

  worksheet.getCell('C27').value = `${data.waibu.fasongkashu}`;
  worksheet.getCell('C27').style = {
    font: {
      name:'微软雅黑',
      size: 10,
    
    }
  
  };
  worksheet.getCell('C27').alignment = { horizontal: 'center', vertical: 'middle' };
  


  worksheet.getCell('D27').value = `张`;
  worksheet.getCell('D27').style = {
    font: {
      name:'微软雅黑',
      size: 10,
    
    }
  
  };
  worksheet.getCell('D27').alignment = { horizontal: 'center', vertical: 'middle' };
  



  worksheet.getCell('E27').value = `${data.waibu.fasongkadanjia}`;
  worksheet.getCell('E27').style = {
    font: {
      name:'微软雅黑',
      size: 10,
    
    }
  
  };
  worksheet.getCell('E27').alignment = { horizontal: 'center', vertical: 'middle' };
  




  worksheet.getCell('F27').value = `${data.waibu.fasongkazong}`;
  worksheet.getCell('F27').style = {
    font: {
      name:'微软雅黑',
      size: 10,
    }
  };
  worksheet.getCell('F27').alignment = { horizontal: 'center', vertical: 'middle' };
  


  worksheet.mergeCells("G27","H27");


  worksheet.getCell('H27').style.border={
    right: {    style: 'medium',
    color: { argb: '#000' },}
  }


  worksheet.getCell('A28').value = `处理器`;




  worksheet.getCell('A28').style = {
    font: {
      name:'微软雅黑',
      size: 10,
    
    }
  
  };
  
  worksheet.getCell('A28').alignment = { horizontal: 'center', vertical: 'middle' };
  worksheet.getCell('A28').style.border = {
  
    left: {    style: 'medium',
  color: { argb: '#000' },}
  };
  worksheet.getCell('B28').value = `${data.waibu.chiliqixing}`;
  worksheet.getCell('B28').style = {
    font: {
      name:'微软雅黑',
      size: 10,
    
    }
  
  };
  worksheet.getCell('B28').alignment = { horizontal: 'center', vertical: 'middle' };
  

  worksheet.getCell('C28').value = `${data.waibu.chuliqishu}`;
  worksheet.getCell('C28').style = {
    font: {
      name:'微软雅黑',
      size: 10,
    
    }
  
  };
  worksheet.getCell('C28').alignment = { horizontal: 'center', vertical: 'middle' };
  


  worksheet.getCell('D28').value = `台`;
  worksheet.getCell('D28').style = {
    font: {
      name:'微软雅黑',
      size: 10,
    
    }
  
  };
  worksheet.getCell('D28').alignment = { horizontal: 'center', vertical: 'middle' };
  



  worksheet.getCell('E28').value = `${data.waibu.chiliqijiage}`;
  worksheet.getCell('E28').style = {
    font: {
      name:'微软雅黑',
      size: 10,
    
    }
  
  };
  worksheet.getCell('E28').alignment = { horizontal: 'center', vertical: 'middle' };
  




  worksheet.getCell('F28').value = `${data.waibu.chuliqizong}`;
  worksheet.getCell('F28').style = {
    font: {
      name:'微软雅黑',
      size: 10,
    }
  };
  worksheet.getCell('F28').alignment = { horizontal: 'center', vertical: 'middle' };
  


  worksheet.mergeCells("G28","H28");


  worksheet.getCell('H28').style.border={
    right: {    style: 'medium',
    color: { argb: '#000' },}
  }
  












  worksheet.getCell('A29').value = `配电柜`;




  worksheet.getCell('A29').style = {
    font: {
      name:'微软雅黑',
      size: 10,
    
    }
  
  };
  
  worksheet.getCell('A29').alignment = { horizontal: 'center', vertical: 'middle' };
  worksheet.getCell('A29').style.border = {
 
    left: {    style: 'medium',
  color: { argb: '#000' },}
  };
  worksheet.getCell('B29').value = `${data.waibu.pdidianguiName}`;
  worksheet.getCell('B29').style = {
    font: {
      name:'微软雅黑',
      size: 10,
    
    }
  
  };
  worksheet.getCell('B29').alignment = { horizontal: 'center', vertical: 'middle' };
  

  worksheet.getCell('C29').value = `${data.waibu.pdidianguishu}`;
  worksheet.getCell('C29').style = {
    font: {
      name:'微软雅黑',
      size: 10,
    
    }
  
  };
  worksheet.getCell('C29').alignment = { horizontal: 'center', vertical: 'middle' };
  


  worksheet.getCell('D29').value = `台`;
  worksheet.getCell('D29').style = {
    font: {
      name:'微软雅黑',
      size: 10,
    
    }
  
  };
  worksheet.getCell('D29').alignment = { horizontal: 'center', vertical: 'middle' };
  



  worksheet.getCell('E29').value = `${data.waibu.peidianguidanjia}`;
  worksheet.getCell('E29').style = {
    font: {
      name:'微软雅黑',
      size: 10,
    
    }
  
  };
  worksheet.getCell('E29').alignment = { horizontal: 'center', vertical: 'middle' };
  




  worksheet.getCell('F29').value = `${data.waibu.peidanguizong}`;
  worksheet.getCell('F29').style = {
    font: {
      name:'微软雅黑',
      size: 10,
    }
  };
  worksheet.getCell('F29').alignment = { horizontal: 'center', vertical: 'middle' };
  
  worksheet.getCell('G29').value='建议价，客户可自备'
  worksheet.getCell('G30').value='建议价，客户可自备'
  worksheet.getCell('G31').value='建议价，客户可自备'
  worksheet.getCell('G32').value='壁挂式'
  worksheet.getCell('G33').value='自备'
  worksheet.mergeCells("G29","H29");


  worksheet.getCell('H29').style.border={
    right: {    style: 'medium',
    color: { argb: '#000' },}
  }
  









  worksheet.getCell('A30').value = `电脑`;




  worksheet.getCell('A30').style = {
    font: {
      name:'微软雅黑',
      size: 10,
    
    }
  
  };
  
  worksheet.getCell('A30').alignment = { horizontal: 'center', vertical: 'middle' };
  worksheet.getCell('A30').style.border = {

    left: {    style: 'medium',
  color: { argb: '#000' },}
  };
  worksheet.getCell('B30').value = `${data.waibu.diannaoname}`;
  worksheet.getCell('B30').style = {
    font: {
      name:'微软雅黑',
      size: 10,
    
    }
  
  };
  worksheet.getCell('B30').alignment = { horizontal: 'center', vertical: 'middle' };
  

  worksheet.getCell('C30').value = `${data.waibu.diannaoshu}`;
  worksheet.getCell('C30').style = {
    font: {
      name:'微软雅黑',
      size: 10,
    
    }
  
  };
  worksheet.getCell('C30').alignment = { horizontal: 'center', vertical: 'middle' };
  


  worksheet.getCell('D30').value = `台`;
  worksheet.getCell('D30').style = {
    font: {
      name:'微软雅黑',
      size: 10,
    
    }
  
  };
  worksheet.getCell('D30').alignment = { horizontal: 'center', vertical: 'middle' };
  



  worksheet.getCell('E30').value = `${data.waibu.dianaodanjia}`;
  worksheet.getCell('E30').style = {
    font: {
      name:'微软雅黑',
      size: 10,
    
    }
  
  };
  worksheet.getCell('E30').alignment = { horizontal: 'center', vertical: 'middle' };
  




  worksheet.getCell('F30').value = `${data.waibu.diannaozong}`;
  worksheet.getCell('F30').style = {
    font: {
      name:'微软雅黑',
      size: 10,
    }
  };
  worksheet.getCell('F30').alignment = { horizontal: 'center', vertical: 'middle' };
  


  worksheet.mergeCells("G30","H30");


  worksheet.getCell('H30').style.border={
    right: {    style: 'medium',
    color: { argb: '#000' },}
  }
  







  worksheet.getCell('A31').value = `空调`;



  worksheet.getCell('A31').style = {
    font: {
      name:'微软雅黑',
      size: 10,
    
    }
  
  };
  
  worksheet.getCell('A31').alignment = { horizontal: 'center', vertical: 'middle' };
  
  worksheet.getCell('A31').style.border = {
    
    left: {    style: 'medium',
  color: { argb: '#000' },}
  };
  worksheet.getCell('B31').value = `${data.waibu.kongtiaoname}`;
  worksheet.getCell('B31').style = {
    font: {
      name:'微软雅黑',
      size: 10,
    
    }
  
  };
  worksheet.getCell('B31').alignment = { horizontal: 'center', vertical: 'middle' };
  

  worksheet.getCell('C31').value = `${data.waibu.kongtiaoshu}`;
  worksheet.getCell('C31').style = {
    font: {
      name:'微软雅黑',
      size: 10,
    
    }
  
  };
  worksheet.getCell('C31').alignment = { horizontal: 'center', vertical: 'middle' };
  


  worksheet.getCell('D31').value = `台`;
  worksheet.getCell('D31').style = {
    font: {
      name:'微软雅黑',
      size: 10,
    
    }
  
  };
  worksheet.getCell('D31').alignment = { horizontal: 'center', vertical: 'middle' };
  



  worksheet.getCell('E31').value = `${data.waibu.kongtiaojiage}`;
  worksheet.getCell('E31').style = {
    font: {
      name:'微软雅黑',
      size: 10,
    
    }
  
  };
  worksheet.getCell('E31').alignment = { horizontal: 'center', vertical: 'middle' };
  




  worksheet.getCell('F31').value = `${data.waibu.kongtiaozong}`;
  worksheet.getCell('F31').style = {
    font: {
      name:'微软雅黑',
      size: 10,
    }
  };
  worksheet.getCell('F31').alignment = { horizontal: 'center', vertical: 'middle' };
  


  worksheet.mergeCells("G31","H31");


  worksheet.getCell('H31').style.border={
    right: {    style: 'medium',
    color: { argb: '#000' },}
  }
  






  worksheet.getCell('A32').value = `框架`;



  worksheet.getCell('A32').style = {
    font: {
      name:'微软雅黑',
      size: 10,
    
    }
  
  };
  
  worksheet.getCell('A32').alignment = { horizontal: 'center', vertical: 'middle' };
  
  worksheet.getCell('A32').style.border = {
  
    left: {    style: 'medium',
  color: { argb: '#000' },}
  };
  worksheet.getCell('B32').value = `${data.waibu.kaungjianame}`;
  worksheet.getCell('B32').style = {
    font: {
      name:'微软雅黑',
      size: 10,
    
    }
  
  };
  worksheet.getCell('B32').alignment = { horizontal: 'center', vertical: 'middle' };
  

  worksheet.getCell('C32').value = `${data.waibu.kuangjiashu}`;
  worksheet.getCell('C32').style = {
    font: {
      name:'微软雅黑',
      size: 10,
    
    }
  
  };
  worksheet.getCell('C32').alignment = { horizontal: 'center', vertical: 'middle' };
  


  worksheet.getCell('D32').value = `平方`;
  worksheet.getCell('D32').style = {
    font: {
      name:'微软雅黑',
      size: 10,
    
    }
  
  };
  worksheet.getCell('D32').alignment = { horizontal: 'center', vertical: 'middle' };
  



  worksheet.getCell('E32').value = `${data.waibu.kaungjiajiage}`;
  worksheet.getCell('E32').style = {
    font: {
      name:'微软雅黑',
      size: 10,
    
    }
  
  };
  worksheet.getCell('E32').alignment = { horizontal: 'center', vertical: 'middle' };
  




  worksheet.getCell('F32').value = `${data.waibu.kaungjiazzong}`;
  worksheet.getCell('F32').style = {
    font: {
      name:'微软雅黑',
      size: 10,
    }
  };
  worksheet.getCell('F32').alignment = { horizontal: 'center', vertical: 'middle' };
  


  worksheet.mergeCells("G32","H32");


  worksheet.getCell('H32').style.border={
    right: {    style: 'medium',
    color: { argb: '#000' },}
  }
  




  worksheet.getCell('A33').value = `安装`;




  worksheet.getCell('A33').style = {
    font: {
      name:'微软雅黑',
      size: 10,
    
    }
  
  };
  
  worksheet.getCell('A33').alignment = { horizontal: 'center', vertical: 'middle' };
  worksheet.getCell('A33').style.border = {
  
    left: {    style: 'medium',
  color: { argb: '#000' },}
  };
  worksheet.getCell('B33').value = `${data.waibu.anzhuangname}`;
  worksheet.getCell('B33').style = {
    font: {
      name:'微软雅黑',
      size: 10,
    
    }
  
  };
  worksheet.getCell('B33').alignment = { horizontal: 'center', vertical: 'middle' };
  

  worksheet.getCell('C33').value = `${data.waibu.anzhuangshu}`;
  worksheet.getCell('C33').style = {
    font: {
      name:'微软雅黑',
      size: 10,
    
    }
  
  };
  worksheet.getCell('C33').alignment = { horizontal: 'center', vertical: 'middle' };
  


  worksheet.getCell('D33').value = `平方`;
  worksheet.getCell('D33').style = {
    font: {
      name:'微软雅黑',
      size: 10,
    
    }
  
  };
  worksheet.getCell('D33').alignment = { horizontal: 'center', vertical: 'middle' };
  



  worksheet.getCell('E33').value = `${data.waibu.anzhaungjiage}`;
  worksheet.getCell('E33').style = {
    font: {
      name:'微软雅黑',
      size: 10,
    
    }
  
  };
  worksheet.getCell('E33').alignment = { horizontal: 'center', vertical: 'middle' };
  




  worksheet.getCell('F33').value = `${data.waibu.anzhuangzong}`;
  worksheet.getCell('F33').style = {
    font: {
      name:'微软雅黑',
      size: 10,
    }
  };
  worksheet.getCell('F33').alignment = { horizontal: 'center', vertical: 'middle' };
  


  worksheet.mergeCells("G33","H33");


  worksheet.getCell('H33').style.border={
    right: {    style: 'medium',
    color: { argb: '#000' },}
  }
  

  worksheet.getCell('A34').value = `小计：`;
  worksheet.mergeCells("A34","E34");
  // 
    worksheet.getCell('A34').style = {
      font: {
        name:'微软雅黑',
        size: 12,
        bold:true
      
      },
      alignment:{ horizontal: 'right', vertical: 'middle' },
      border:{
          left: {    style: 'medium',
          color: { argb: '#000' },},
          bottom: {    style: 'medium',
          color: { argb: '#000' },}
        }
    
    };
  
    worksheet.getCell('F34').value = `${waibuzong}`;
  worksheet.mergeCells("G34","H34");
  // 
    worksheet.getCell('F34').style = {
      font: {
        name:'微软雅黑',
        size: 12,
        bold:true
      
      },
      alignment:{ horizontal: 'center', vertical: 'middle' },
      border:{
        
          bottom: {    style: 'medium',
          color: { argb: '#000' },}
        }
    
    };

  
      worksheet.getCell('B34').style = {
   
     
        border:{
          
            bottom: {    style: 'medium',
            color: { argb: '#000' },}
          }
      
      };

      worksheet.getCell('C34').style = {
   
     
        border:{
          
            bottom: {    style: 'medium',
            color: { argb: '#000' },}
          }
      
      };

      worksheet.getCell('D34').style = {
   
     
        border:{
          
            bottom: {    style: 'medium',
            color: { argb: '#000' },}
          }
      
      };



      worksheet.getCell('E34').style = {
   
     
        border:{
          
            bottom: {    style: 'medium',
            color: { argb: '#000' },}
          }
      
      };


  



      worksheet.getCell('G34').style = {
   
        font: {
            name:'微软雅黑',
            size: 12,
            bold:true
          
          },
          alignment:{ horizontal: 'center', vertical: 'middle' },
     
        border:{
          
            bottom: {    style: 'medium',
            color: { argb: '#000' },}
          }
      
      };
      worksheet.getCell('H34').value="未税金额"
      worksheet.getCell('H34').style = {
   
      
        border:{
          
            bottom: {    style: 'medium',
            color: { argb: '#000' },},
            right: {    style: 'medium',
            color: { argb: '#000' },}
          }
      
      };






      worksheet.mergeCells("A35","H35");
      worksheet.getCell('A35').value = `四，合计总价`;
      worksheet.getCell('A35').style = {
        font: {
          name:'微软雅黑',
          size: 12,
          bold: true
        },
      
      }; 
      
      worksheet.getCell('A35').style.border = {
        top: {
        
          style: 'medium',
              color: { argb: '#000' }
        },
      
        left: {
          style: 'medium',
          color: { argb: '#000' },
      },
        bottom: {    style: 'medium',
        color: { argb: '#000' },},
        right: {    style: 'medium',
        color: { argb: '#000' },}
      };
      worksheet.getCell('B35').style.border = {
        top: {
        
          style: 'medium',
              color: { argb: '#000' }
        },
      
        left: {
          style: 'medium',
          color: { argb: '#000' },
      },
        bottom: {    style: 'medium',
        color: { argb: '#000' },},
        right: {    style: 'medium',
        color: { argb: '#000' },}
      };
      worksheet.getCell('C35').style.border = {
        top: {
        
          style: 'medium',
              color: { argb: '#000' }
        },
      
      
      };
      worksheet.getCell('D35').style.border = {
        top: {
        
          style: 'medium',
              color: { argb: '#000' }
        },
      
      
      };
      worksheet.getCell('E35').style.border = {
        top: {
        
          style: 'medium',
              color: { argb: '#000' }
        },
      
      
      };
      worksheet.getCell('F35').style.border = {
        top: {
        
          style: 'medium',
              color: { argb: '#000' }
        },
      
      
      };
      
      worksheet.getCell('G35').style.border = {
        top: {
        
          style: 'medium',
              color: { argb: '#000' }
        },
      
      
      };
      worksheet.getCell('H35').style.border = {
        top: {
        
          style: 'medium',
              color: { argb: '#000' }
        },
      
      
        bottom: {    style: 'medium',
        color: { argb: '#000' },},
        right: {    style: 'medium',
        color: { argb: '#000' },}
      };


    //   worksheet.getCell('A36').value=""


// worksheet.mergeCells("A11","H11");
worksheet.getCell('A36').value = `单套未税金额`;
worksheet.getCell('A36').style = {
  font: {
    name:'微软雅黑',
    size: 10,
    bold: true
  }

};
// 字体对齐
worksheet.getCell('A36').alignment = { horizontal: 'center', vertical: 'middle' };
// 边框颜色
worksheet.getCell('A36').style.border = {
  left: {    style: 'medium',
  color: { argb: '#000' },}
};
// 背景色
worksheet.getCell('A36').fill = {
  type: 'pattern',
  pattern: 'solid',
  fgColor: {argb:'c6e0b4'}
};
worksheet.getCell('B36').value=`（屏体${(+data.wai.pingtizong+Number(data.bei.zongjia)).toFixed(2)}元）+（外部${waibuzong}元）`
worksheet.mergeCells("B36","E36");

worksheet.getCell('B36').style = {
    font: {
      name:'微软雅黑',
      size: 10,
      bold: true
    }
  
  };
  
  // 字体对齐
  worksheet.getCell('B36').alignment = { horizontal: 'center', vertical: 'middle' };
//   // 边框颜色
  worksheet.getCell('B36').style.border = {
    left: {    style: 'thin',
    color: { argb: '#000' },}
  };
  // 背景色
  worksheet.getCell('B36').fill = {
    type: 'pattern',
    pattern: 'solid',
    fgColor: {argb:'c6e0b4'}
  };
  



  worksheet.getCell('F36').value = `${(+data.wai.pingtizong+Number(data.bei.zongjia)+Number(waibuzong)).toFixed(2)}`
  worksheet.getCell('F36').style = {
    font: {
      name:'微软雅黑',
      size: 10,
      bold: true
    }
  
  };
  
  // 字体对齐
worksheet.getCell('F36').alignment = { horizontal: 'center', vertical: 'middle' };
// 边框颜色
worksheet.getCell('F36').style.border = {
  left: {    style: 'thin',
  color: { argb: '#000' },}
};
// 背景色
worksheet.getCell('F36').fill = {
  type: 'pattern',
  pattern: 'solid',
  fgColor: {argb:'c6e0b4'}
};



worksheet.getCell('G36').value="未税金额"
worksheet.mergeCells("G36","H36");

  // 字体对齐
 
 
    // 边框颜色
    worksheet.getCell('H36').style.border = {
        right: {    style: 'medium',
        color: { argb: '#000' },},
       
      };

  
      

  worksheet.getCell('G36').style = {
    font: {
      name:'微软雅黑',
      size: 10,
      bold: true
    }
  
  };
  worksheet.getCell('G36').alignment = { horizontal: 'center', vertical: 'middle' };
  // 背景色
  worksheet.getCell('G36').fill = {
    type: 'pattern',
    pattern: 'solid',
    fgColor: {argb:'c6e0b4'}
  };
 // 边框颜色
 worksheet.getCell('G36').style.border = {
    left: {    style: 'thin',
    color: { argb: '#000' },}
  };
  worksheet.getCell('A37').value = `单套含税金额：`;
  worksheet.mergeCells("A37","E37");
  // 
    worksheet.getCell('A37').style = {
      font: {
        name:'微软雅黑',
        size: 12,
        bold:true,
        color: { argb: 'FFFF0000' } // 红色
      
      },
      alignment:{ horizontal: 'right', vertical: 'middle' },
      border:{
          left: {    style: 'medium',
          color: { argb: '#000' },},
          top: {    style: 'thin',
          color: { argb: '#000' },}
        }
    
    };


     // 背景色
  worksheet.getCell('A37').fill = {
    type: 'pattern',
    pattern: 'solid',
    fgColor: {argb:'bdd7ee'}
  };

      worksheet.getCell('H37').style = {
   

        border:{
        
         right:{ style: 'medium',
         color: { argb: '#000' },},
            top: {    style: 'thin',
            color: { argb: '#000' },}
          }
      
      };
  
      worksheet.getCell('F37').value=shul
      worksheet.getCell('G37').value='含税金额'
      worksheet.getCell('G37').style = {
   
        font: {
            name:'微软雅黑',
            size: 10,
            bold:true,
            color: { argb: 'FFFF0000' } // 红色
          
          },
          alignment:{ horizontal: 'right', vertical: 'middle' },
        border:{
         left:{  style: 'thin',
         color: { argb: '#000' },},
            top: {    style: 'thin',
            color: { argb: '#000' },}
          }
      
      };

   // 背景色
   worksheet.getCell('G37').fill = {
    type: 'pattern',
    pattern: 'solid',
    fgColor: {argb:'bdd7ee'}
  };

      worksheet.getCell('F37').style = {
        font: {
            name:'微软雅黑',
            size: 10,
            bold:true,
            color: { argb: 'FFFF0000' } // 红色
          
          },
          alignment:{ horizontal: 'center', vertical: 'middle' },

        border:{
         left:{ style: 'thin',
         color: { argb: '#000' },},
            top: {    style: 'thin',
            color: { argb: '#000' },}
          }
      
      };
    
      // 背景色
     worksheet.getCell('F37').fill = {
        type: 'pattern',
        pattern: 'solid',
        fgColor: {argb:'bdd7ee'}
      };
     // 背景色
     worksheet.getCell('H37').fill = {
        type: 'pattern',
        pattern: 'solid',
        fgColor: {argb:'bdd7ee'}
      };

  worksheet.getCell('B37').style = {
   

    border:{
     
        top: {    style: 'thin',
        color: { argb: '#000' },}
      }
  
  };

  worksheet.getCell('C37').style = {
   

    border:{
     
        top: {    style: 'thin',
        color: { argb: '#000' },}
      }
  
  };

  worksheet.getCell('D37').style = {
   

    border:{
     
        top: {    style: 'thin',
        color: { argb: '#000' },}
      }
  
  };
  worksheet.getCell('E37').style = {
   

    border:{
     left:{ style: 'thin',
     color: { argb: '#000' },},
        top: {    style: 'thin',
        color: { argb: '#000' },}
      }
  
  };
  worksheet.getCell('A38').value="报价中所有尺寸、材料数量、及价格客户在制作前需仔细核对，制作时一旦有误，客户自行负责"
  worksheet.mergeCells("A38","H38");
  worksheet.getCell('A38').style = {
    font: {
        name:'微软雅黑',
        size: 10,
       
        color: { argb: '0000' } // 红色
      
      },
      alignment:{ horizontal: 'center', vertical: 'middle' },

    border:{
  
        top: {    style: 'medium',
        color: { argb: '#000' },},
        left: {    style: 'medium',
        color: { argb: '#000' },},
       
      }
  
  };
  worksheet.getCell('B38').style = {
  
     

    border:{
  
        top: {    style: 'medium',
        color: { argb: '#000' },}
      }
  
  };


  worksheet.getCell('C38').style = {
  
     

    border:{
  
        top: {    style: 'medium',
        color: { argb: '#000' },}
      }
  
  };
  worksheet.getCell('D38').style = {
  
     

    border:{
  
        top: {    style: 'medium',
        color: { argb: '#000' },}
      }
  
  };

  worksheet.getCell('E38').style = {
  
     

    border:{
  
        top: {    style: 'medium',
        color: { argb: '#000' },}
      }
  
  };
  worksheet.getCell('F38').style = {
  
     

    border:{
  
        top: {    style: 'medium',
        color: { argb: '#000' },}
      }
  
  };
  worksheet.getCell('G38').style = {
  
     

    border:{
  
        top: {    style: 'medium',
        color: { argb: '#000' },}
      }
  
  };
  worksheet.getCell('H38').style = {
  
     

    border:{
right:{  style: 'medium',
color: { argb: '#000' },},
        top: {    style: 'medium',
        color: { argb: '#000' },}
      }
  
  };


  worksheet.getRow(39).height = 80;
  worksheet.getCell('A39').value='温馨提示：'

  worksheet.getCell('A39').style = {
  
    font: {
        name:'微软雅黑',
        size: 14,
       bold:true,
        color: { argb: '0000' } // 红色
      
      },
      alignment:{ horizontal: 'center', vertical: 'middle' },

   
  
  };
  worksheet.getCell('A39').style.border = {
    left: {    style: 'medium',
    color: { argb: '#000' },},
    bottom: {    style: 'medium',
    color: { argb: '#000' },},
    
   
  };


  //  // 边框颜色


  worksheet.mergeCells("B39","H39");

  worksheet.getCell('B39').value=`
  1、有需要电脑的要配独立显卡要有DVI接口.
  2、本屏主网线需要4根（可加1-2根网线备用），网线，主电源线放到位。
  3、本屏主电源线按照（18200W）左右功率进行安放`

  worksheet.getCell('B39').style = {
  
    font: {
        name:'微软雅黑',
        size: 10,
      
        color: { argb: '0000' } // 红色
      
      },
      alignment:{ horizontal: 'left', vertical: 'middle',wrapText: true },

//     border:{
// right:{  style: 'medium',
// color: { argb: '#000' },},
//         top: {    style: 'medium',
//         color: { argb: '#000' },}
//       }


  
  };



   // 边框颜色
   worksheet.getCell('H39').style.border = {
    right: {    style: 'medium',
    color: { argb: '#000' },},
    bottom: {    style: 'medium',
    color: { argb: '#000' },},
    
   
  };
   // 边框颜色
   worksheet.getCell('B39').style.border = {
  
    bottom:{  style: 'medium',
    color: { argb: '#000' },}
   
  };

  worksheet.getCell('G40').value=`报价时间：${shijiandata}`
  worksheet.mergeCells("G40","H40");
// 边框颜色
// worksheet.getCell('G39').style.border = {
//   right: {    style: 'medium',
//   color: { argb: '#000' },},
 
// };




// worksheet.mergeCells("G17","H17");
// worksheet.mergeCells("G17","H18");
 // 保存文件
 workbook.xlsx.writeFile('public/myFile.xlsx')
 .then(function() {
   console.log('File saved.');
 });
res.send({code:200,
status:'表格生成成功！'})

}
